package com.atguigu.userprofile.dao;

import com.atguigu.userprofile.bean.TaskTagRule;
import com.atguigu.userprofile.util.MySQLUtil;

import java.util.List;

public class TaskTagRuleDAO {

    public static  List<TaskTagRule> getTaskTagRuleList(String taskId) {
        String sql =" select tr.* ,ti.tag_name as sub_tag_value " +
                "from task_tag_rule tr join tag_info ti  on tr.sub_tag_id=ti.id where tr.task_id="+taskId ;
        List<TaskTagRule> taskTagRuleList = MySQLUtil.queryList(sql, TaskTagRule.class, true);
        return taskTagRuleList;
    }
}
